<?php

$installer = $this;

$installer->startSetup();

$installer->run("

-- DROP TABLE IF EXISTS {$this->getTable('advancedmenu')};
CREATE TABLE {$this->getTable('advancedmenu')} (
  `advancedmenu_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) NULL default '',
  `url_key` varchar(255) NULL default '',
  `css_id` varchar(255) NULL default '',
  `css_class` varchar(255) NULL default '',
  `store_id` int(11) NULL ,
  `static_block` int(11) NULL ,
  `order` int(11) NULL default '0',
  `status` smallint(6) NOT NULL default '0',
  `created_time` datetime NULL,
  `update_time` datetime NULL,
  PRIMARY KEY (`advancedmenu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    ");

$installer->endSetup(); 